package com.meet.dao;

import com.meet.entity.Workers;
import com.meet.vo.WorkersVo;

import java.sql.SQLException;
import java.util.List;

/**
 * @Author LiDianyang
 * @Date 2022/8/11 19:29
 * @PackageName:com.meet.dao
 * @ClassName: WorkersDao
 * @Description: TODO
 * @Version 1.0
 */
public interface WorkersDao {



    //插入员工
    public int addWorkers(Workers workers) throws SQLException;
    //修改员工
    public int updateWorkers(Workers workers) throws SQLException;
    //删除员工
    public int deleteWorkers(Integer id) throws SQLException;
    //获取员工中的总记录数
    public int getCount() throws SQLException;

    public Workers getWorkers(Integer id) throws SQLException;

    //登陆查找
    public Workers getWorkers(String name, String password) throws SQLException;

    //分页查询
    public List<WorkersVo> getWorkersCard(int page, int number) throws SQLException;


    //------------lxw增加的----
    public List<Workers> getAllWorkers() throws SQLException;

    /** 获取所有员工数据
     * @author King_of_hehe
     * @return
     * @throws SQLException
     */
    public List<Workers> getAll() throws SQLException;
//曾广龙
    public WorkersVo getWorkersVo(Integer id) throws SQLException;

    public int updateWorkersphone(Workers workers) throws SQLException;

}
